Excel lost blurred lines [DETAILED HOW TO FIX]

Excel lost its blurred lines and you're having a headache because you haven't found a way to fix it? TipsMake has revealed to you the detailed solution

Excel lost its blurred lines and you're having a headache because you haven't found a way to fix it? TipsMake has revealed to you the detailed solution in the article. Don't miss out if this is the information you need!

For those of you who work with Excel, you are probably familiar with blurred lines. These lines help us identify cells in Excel. Usually, they will be drawn in columns and rows. However, some users suddenly do not see these blurred lines when experiencing it.

Therefore, how to fix the error of Excel losing blurred lines is of great interest. The next section will help you solve this problem.

Excel lost blurred lines [DETAILED HOW TO FIX] Picture 1Excel lost blurred lines [DETAILED HOW TO FIX] Picture 1

Share how to fix the problem of Excel losing blurred lines

If you don't see the blurred lines, don't assume this is a missing line error in Excel. Because you simply accidentally hid these blurred lines. Here are ways to display this blurred line again.

1/ How to get back lines in Excel

There is a high possibility that you have unchecked the Gridlines box so the new lines are blurred. Or users press the key combination Alt+W+VG so they won't see the watermark. The way to show it is very simple as follows:

  1. Step 1 : The user clicks on the View tab in the Excel file that is losing blurred lines.
  2. Step 2 : Find the Show area > Tick the Gridlines box and the blurred lines will immediately appear on your Excel file.

Excel lost blurred lines [DETAILED HOW TO FIX] Picture 3Excel lost blurred lines [DETAILED HOW TO FIX] Picture 3

2/ How to display Excel blurred lines again in Settings

Many users have set the blurred lines to turn off permanently so the blurred lines cannot be seen in all your Excel files when opened. To fix the problem of the Excel table losing its lines in this case, you just need to:

  1. Step 1 : In the open Excel file, click on the File tab > Click on Options .
  2. Step 2 : In the new window, click on the Advanced tab > Go to Display options for this worksheet > Tick the Show gridlines box > Click OK to save the settings to complete this process.

Excel lost blurred lines [DETAILED HOW TO FIX] Picture 4Excel lost blurred lines [DETAILED HOW TO FIX] Picture 4

FOLLOW MORE

  1. Alt + Enter does not break the line in Excel and what you need to do
  2. Excel does not allow inserting additional columns and rows [FIXED] 

Share how to fix errors in Excel with lost lines effectively

In addition to the above situation, many of you also encounter the problem of lost lines in Excel and don't know what to do. Here are 2 ways for you to fix this problem!

Solution 1

  1. Step 1 : The user opens his Excel file > Then, click on the Page Layout tab .
  2. Step 2 : Tick the Print box (located below the Gridlines section in the Sheets Option section) > Press Ctrl + P to test and you will see the blurred lines printed.

Excel lost blurred lines [DETAILED HOW TO FIX] Picture 6Excel lost blurred lines [DETAILED HOW TO FIX] Picture 6

Solution 2

Before printing, you just need to change the color of the lines to help avoid the situation where blurred lines are lost in Excel printing. To do this, you also click on Excel's File tab > Options > Advanced in the left menu when the window displays.

Next, go to Display options for this worksheet > Tick the Show gridlines box > Select the grid line color in the Gridline Color box > Click OK and check to see if the problem has been fixed or not.

Excel lost blurred lines [DETAILED HOW TO FIX] Picture 8Excel lost blurred lines [DETAILED HOW TO FIX] Picture 8

TipsMake has finished sharing how to fix the problem of Excel losing blurred lines. Hopefully the tips I share will help you fix the error successfully!

4.5 ★ | 2 Vote